Tech Arsenal 1

home *** CD-ROM | disk | FTP | other *** search

/ Tech Arsenal 1 / Tech Arsenal (Arsenal Computer).ISO / tek-04 / sellmor2.zip / REINDEX.DBF (.txt) < prev next >

Wrap

dBase/FoxBase/XBase Database File | 1992-08-04 | 13KB | 89 rows

#	DATABASE,C,12	INDEX,C,12	KEY_FIELD,C,80	DESCRIP,C,40
1	FUNCKEYS	FUNCKEYS	FUNC_KEY	FUNCTION KEY ASSIGNMENTS
2	USERS	USERS1	UPPER(LOCATION)
3	USERS	USERS2	DESCRIP
4	HELP	HELP	FIELD_DB+FIELD_NAME	DATABASE + FIELDNAME
5	CLIENTS	CLIENTS1	CLIENT	CLIENT NUMBER
6	CLIENTS	CLIENTS2	UPPER(LEFT(TRIM(LNAME)+TRIM(FNAME)+COMPANY,40))	LAST+FIRST+COMPANY
7	CLIENTS	CLIENTS3	UPPE(LEFT(TRIM(COMPANY)+TRIM(STATE+CITY)+LNAME+SPAC(40),40))	COMPANY
8	PROJECT	PROJECT1	PROJECT	PROJECT
9	PROJECT	PROJECT2	DESCRIP	DESCRIPTION
10	OBJECTIV	OBJECT1	PROJECT+PROGRAM	PROJECT
11	OBJECTIV	OBJECT2	DESCRIP	DESCRIP
12	EVENTS	EVENTS1	PROJECT+PROGRAM+DTOS(DATEIN)	PROJECT
13	EVENTS	EVENTS2	INV_NUM+IIF(CLIENT#"SHAR",PROJECT+PROGRAM+DTOS(DATEIN),SPACE(20))
14	DETAILS	DETAILS2	PROJECT+PROGRAM+DTOS(DATEIN+7*VAL(PRIORITY))
15	DETAILS	DETAILS1	DONEBY+DTOS(DATEIN+7*VAL(PRIORITY))+PROJECT
16	DETAILS	DETAILS3	DTOS(DATEIN+7*VAL(PRIORITY))
17	DISKETTE	DISKETTE	SERIAL
18	ACCOUNTS	ACCOUNT1	ACCOUNT_ID	ACCOUNT NUMBER
19	ACCOUNTS	ACCOUNT2	DESCRIP	DESCRIPTIVE
20	ACCTDESC	ACCTDES1	ACCOUNT_ID	"1,2,3,4 OR 5"
21	ACCTDESC	ACCTDES2	DESCRIP	DESCRIPTIVE
22	LEDGER	LEDGER	ACCOUNT_ID+DTOS(DATE)	GENERAL LEDGER
23	DEPT	DEPT1	DEPT	DEPARTMENT CODE
24	DEPT	DEPT2	DESCRIP	DESCRIPTIVE
25	JOURNAL	JOURNAL	STR(TRANS,4)
26	EMPLOYEE	EMPLOY1	DONEBY
27	PRINTERS	PRINTER1	STR(RECNO(),2)	PRINTER ID NO.
28	PRINTERS	PRINTER2	UPPER(DESCRIP)	PRINTER DESCRIPTION
29	EVENTS	EVENTS3	BATCH	BATCH NUMBER
30	EMPLOYEE	EMPLOY2	NAME
31	INVOICE	INVOICE1	INVOICE
32	INVOICE	INVOICE2	CLIENT+DESCEND(INVOICE)
33	INVOICE	INVOICE3	PROJECT+INVOICE
34	PROGRAMS	PROGRAM1	PROJECT
35	PROGRAMS	PROGRAM2	DESCRIP
36	PROGRAMS	PROGRAM3	TIER+PROJECT
37	ERRTRACK	ERROR1	SERIAL_NUM+DESCEND(DTOS(ENTERED))
38	QUESTION	QUEST1	PROJECT+UPPER(LEFT(DESCRIP,10))
39	CONTACTS	CONTACT1	CLIENT+DESCEND(DTOS(DATE))+DESCEND(CTIME)
40	CLIENTS	CLIENTS4	LEFT(CLIENT,4)+STR(10000-VAL(SUBSTR(CLIENT,5,4)))	INVERSE SORT
41	SUPPORT	SUPPORT1	SERIAL_NUM
42	SUPPORT	SUPPORT2	CLIENT+SUBSTR(SERIAL_NUM,5,1)+SERIAL_NUM
43	SUPPORT	SUPPORT3	PROJECT+CLIENT
44	CLIENTS	CLIENTS5	SALES_REP+DTOS(DATE)+TIME	NEXT CONTACT
45	CONTACTS	CONTACT2	PROJECT+DTOS(DATE)
46	QUESTION	QUEST2	PROJECT+UPPER(KEYWORD)
47	ERRTRACK	ERROR2	CLIENT+DESCEND(DTOC(ENTERED))
48	ERRTRACK	ERROR3	PROJECT
49	SUPPORT	SUPPORT4	LEFT(SERIAL_NUM,5)+STR(10000-VAL(SUBS(SERIAL_NUM,6,4)))	INVERSE SORT
50	CLIENTS	CLIENTS6	STATE+UPPER(CITY)+UPPER(LEFT(COMPANY,20))+UPPER(LNAME)	STATE+CITY+COMPANY
51	CLIENTS	CLIENTS7	SALES_REP+LEFT(CLIENT,4)+DTOS(DATE)+TIME	NEXT PROJECT
52	POSTAGE	POSTAGE1	PROJECT+DEPT	PROJECT CODE+COST CENTER
53	POSTAGE	POSTAGE2	DTOS(DATE)	DATE
54	INVENTOR	INVENT1	STOCK_NUM	STOCK NUMBER
55	INVENTOR	INVENT2	DESCRIP	DESCRIPTION
56	STATE	STATE1	ST_AB	STATE ABBREVIATION
57	STATE	STATE2	ST_NAME	STATE NAME
58	SOURCES	SOURCES	STOCK_NUM	STOCK NUMBER
59	RELEASE	RELEASE1	CODE
60	RELEASE	RELEASE2	DESCRIP
61	CONTACTS	CONTACT3	DONEBY+DESCEND(DTOS(DATE))
62	ERRTRACK	ERROR5	KEYWORDS
63	ERRTRACK	ERROR4	DESCRIP
64	LEASE	LEASE	CLIENT	LEASE
65	CLIENTS	CLIENTS8	ZIP
66	COMPANY	COMPANY1	COMPNO
67	COMPANY	COMPANY2	UPPER(COMPANY)
68	COMPANY	COMPANY3	UPPER(STATE+CITY+COMPANY)
69	COMPANY	COMPANY4	ZIP
70	COMPANY	COMPANY5	LEFT(COMPNO,4)+STR(10000-VAL(SUBS(COMPNO,5,4)))
71	FILTER	FILTER1	FILE_NAME+FILT_CODE
72	FILTER	FILTER2	FILE_NAME+UPPER(DESCRIP)
73	UPS	UPS1	CLIENT
74	UPS	UPS2	UPPER(LNAME)
75	UPS	UPS3	UPPER(COMPANY)
76	EMPLOYEE	EMPLOY3	SSN	SSN
77	EMPLOYEE	EMPLOY4	UPPER(LNAME+FNAME)	NAME
78	PRCLIENT	PRCLIEN1	CLNO	CLIENT NUMBER
79	PRCLIENT	PRCLIEN2	UPPER(CLIENT)	CLIENT NAME
80	PAYROLL	PAYROLL1	SSN+DTOS(PAY_DATE)	SSN + PAY DATE
81	PAYROLL	PAYROLL2	DTOS(PAY_DATE)+SSN	PAY DATE + SSN
82	PAYROLL	PAYROLL3	CKNO	CKNO
83	TAXSCHD	TAXSCHD	TAX_AUTH+FIL_STAT
84	HISTORY	HISTORY1	SSN +DTOS(PAY_DATE)	SSN + PAY_DATE
85	HISTORY	HISTORY2	DTOS(PAY_DATE)+SSN	PAY_DATE + SSN
86	HISTORY	HISTORY3	CKNO	CKNO
87	W2YEAR	W2YEAR1	SSN	SSN
88	INFOREQ	INFOREQ	CLIENT